Informática Multimedia 1995 April

home *** CD-ROM | disk | FTP | other *** search

/ Informática Multimedia 1995 April / Informatica Multimedia CD - Epimundo.iso / DOS / FILE_CHG / CUTZSDF.ZIP / CUTZ-SDF.DOC < prev next >

Wrap

Text File | 1990-08-08 | 32.9 KB | 611 lines

C U T Z - S D F COPYRIGHT 1990 by David Roper 201 Winding Brook Drive Garner, NC 27529 Copy Freely and give to others (Pay me nothing, Enjoy it) This is a specialized "tool" which will help computer workers to "CUT and change" the SDF type files that are produced by MainFrame computers when they download data for a PC. Also, some database programs use the SDF format to share data. New terms? SDF means "Standard Data Format" to some people. SDF means "Standard Delimited File" to others, SDF means TEXT-EDITOR to some others, and SDF means "Stupid, Dumb, Frustrating" to others. SDF is a type of record where all the FIELDS "run" together, next to each other, no delimeters for fields, and each RECORD (made up of many fields, remember?) is separated by a Carriage Return and LineFeed so that you CAN see them and read them using any word processors which can handle ASCII text. The little DEMO at the beginning of the program has 10 "one- character fields," FYI. Any of the Demo screens or the other timed screens can be speeded-up by pressing ENTER or any other key. A reward for those of you who have read this far. Here is a synopsis of the features of CUTZ-SDF so you won't have to read this whole DOC file to understand what it does. If you have a SDF file, you may want to ADD bytes (chrs) to it or DELETE bytes (chrs) from it before you append it to a dBASE file or any other file or DATABASE. I used to use my trusty WORD PROCESSOR. It works, but slowly, and a pain in the ASCII. CUTZ-SDF was "born...." so that it will do these "tricks:" Relax, you should be able to run CUTZ-SDF WITHOUT reading any further than this line here!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Go ahead, do a DIR, now, to find a sample DATA set and TRY it WITHOUT reading any more. Then come back to here!!!!!!!!!!! --------------------------------------------------------------- (1) INSERT (or Add) characters to a record as if you had CUT the record, inserted the characters into the middle, and then glued the pieces of the record back together again. (2) DELETE characters in any column (any position), because you may not NEED TO USE or append THAT field to a database. (3) PAD all records at the Left side or the Right side in order for them to be a certain, known length for importing. (4) CHANGE will find a string of characters at a certain location and replace all of them with something else. This is like a Global Search and Replace, but Selective, because it will only CHANGE it IF it finds a match. (5) LOOKUP.....part of CHANGE, also. Look at a certain position and if it matches with a value in the LOOKUP file then replace with the value (or string) that you want it to be. This is a VERY selective Search and Replace because you can have up to twenty-five items to LOOK FOR in a position and twenty-five matching REPLACEMENTS FOR IT. See instructions below under the paragraph "LOOKUP." (6) FILTER will allow you to Filter or "Pull out," or "Yank" records that match a certain string in a certain position. Useful if you want another file made from a master source file. FILTER, or Yank, just the 1989 Patient records from a much larger file containing 1985, 1986, 1987, 1988, 1989, and 1990 records. (7) MOVE a part of a record to another part of the record. This is as if you had scissors and were able to CUT and PASTE. The size of the record will not change. You will be just moving things around inside each record. Often, you will have to change a DATE like 07/04/76 to 76/07/04. (8) Use Switch /H to HACK. This will HACK or CUT the file into two Horizontal pieces. You can specify the size to make the LEFT side,....the RIGHT side will be what is left over. Later, you can GLUE the pieces back together to make it "whole" again. Example: make a file with records of 1000 bytes each, into two files with records of 400 each and 600 bytes each. See the picture below for an example of this. (9) Use Switch /F to FIX a file so that each record is a certain length or a certain size, insuring each record will be that certain size by padding it or cutting it. The PAD character can be specified, /P ##, to be ANY ASCII character. (10) Use Switch /S 1 to make the delay 1 second between each screen in the program in case you want to speed it up. Likewise, /S 6 will slow the demo down to 6 seconds per screen if you need more time between screens. (11) Use Switch /T to TEST your file and tell you what size it is, maximum record length, minimum record length, etc. (12) When you are viewing a record from your file (to use as an example), you can view another by using the Up and Down Arrow keys. The HOME key will return to RECORD #1. Alt-J will allow you to go to any record number if you know it. This next thing will be a "problem" for some of you to "swallow." CUTZ-SDF does "require" that when you CREATE your new, altered version of the original file, you give it a NUMBER (from 1 to 998) for the 3-character extension. It's for YOUR benefit because the extensions are incremented as you create new files each time. For example: If your original file is named MY-DATA.SDF, then make the first (1st) version of your altered data with this name: MY-DATA.1, the second version into: MY-DATA.2, etc.... never, ever touching the original data. Now, let's look at some sample data.... Here's an example of 5 records (60 bytes each) in SDF format ROPER DAVID GARNER NC 27529CUTZSDF1EXE112089SWM MCDUFFIE KATHRYN RALEIGH NC 27611CUTZSDF2COM122789DMF TRUMAN TEE WILSON NC 27456CUTZSDF3EXE050990SBM BRANCOWITZ ADRIAN ELLOREE SC 29876CUTZSDF4COM051090BDW WILSON KAY COLUMBIA SC 29206CUTZSDF5EXE051290SWW ^---------------------^-----------^----------------^^--^^--- 123456789012345678901234567890123456789012345678901234567890 1 2 3 4 5 6 The above line of 60 numbers is a "ruler" so you won't have to count 60 characters across in this example. If you look at them, you can tell that the LASTNAME field starts at position #1, the CITY at position #23, the date at pos. #52 With CUTZ-SDF, you can DELETE (take out) the extra space at position #35. It's marked for you with a carat, little hat^. With CUTZ-SDF, you can MOVE the year at pos. #56 and #57 to between the extension types and the months. Then the YEAR would come first, and the MONTH second, and the DAY third. May 5th, 1990 as an example: 051290 becomes 900512. Then you could add the prefix "19" to the year so it becomes this: 19900512 These positions are marked with a carat, a little hat^. Here is the group of the above SDF records after the "DELETE position 35," the "MOVE the year to the left," and the "INSERT or ADD the 19" to the 2 digits for the year at positions 53 and 54. See below, the years 89 and 90 in positions 53 and 54. ROPER DAVID GARNER NC27529CUTZSDF1EXE19891120SWM MCDUFFIE KATHRYN RALEIGH NC27611CUTZSDF2COM19891227DMF TRUMAN TEE WILSON NC27456CUTZSDF3EXE19900509SBM BRANCOWITZ ADRIAN ELLOREE SC26543CUTZSDF4COM19900510BDW WILSON KAY COLUMBIA SC29206CUTZSDF5EXE19900512SWW /\ ^^'' 1234567890123456789012345678901234567890123456789012345678901 1 2 3 4 5 6 Notice that the size of each record increased by 1 character. We added 2 chrs, "19"; subtracted 1, " "; for a net addition of ONE, 1, character to the record....to EACH record. 2 - 1 = 1. Each time you run CUTZ-SDF.EXE, you will be prompted for the name (add the path if needed) of your SDF file. You should rename the SDF file so that it has a number from 1 to 998 for the extension. Example: MYDATA.SDF becomes MYDATA.1 Each time you manipulate the SDF data, you will make a new file with a new extension number. IF YOU USE NUMBERS FOR THE EXTENSIONS, THEN ALL YOU HAVE TO DO TO MAKE ANOTHER FILE (after the initial one) is to PRESS [Enter]. It's easy, you'll see. First, it's CUTZTEST.1, then CUTZTEST.2, then CUTZTEST.3, etc. If you start with CUTZTEST.100, the next would be CUTZTEST.101, etc. Extensions cannot go above 999 obviously, there's a trap for that in case you want to test it... If you make more than 999 changes, you need a new DATA DOWNLOAD, you don't need this program to make THAT many fixes. You always see the first record of the file to use as a guide. As distributed from me, "CUTZ-SDF" comes with a "CUTZTEST.1" file for you to see and play with. If you don't like the first record being the example to use, then you can press the down arrow for the next record, etc., etc. You can return to the first record again by pressing the HOME key if you "stray too far" using the UP ARROW and DOWN ARROW keys. The effective length of the record to be altered is about 400 bytes or so. CUTZ-SDF will actually do more, but the screen will not hold but 2000 characters total, remember, 80 X 25? Use the /HACK switch (below) if you need to work with pieces that will fit onto the screen. Then /GLUE them back together. PADDING means to add characters onto the left or right side of a record. Some SDF files must be padded to be a certain size. CUTZ-SDF will do this for you easily, also. ╔═════════════════╗ ║ S W I T C H E S ║ ╚═════════════════╝ There are six command line switches which may be of use to you. They are /T, /F, /P, H, /G, and /S . All one letter. /T is to Test a file for Max and Min record lengths, etc. /F is to Fix the lengths of records /P is for the Pad character definition (optional) /H for Hacking /G for Gluing /S for the number of Seconds in a display, normally 2 seconds -------------------------------------------------------------- /H ### will HACK (or Cut) ### bytes from each of the records and force them into a LEF_t file and a RIG_ht file with extensions to match! ".LEF" and ".RIG" are the names. /G Will GLUE those two files together again - side by side. Humpty Dumpty needed this one. These two features, /H and /G, will allow you to use CUTZ-SDF with large files (records longer than 400 bytes or so.) examples: To HACK (CUTZ) the "front", "first", "left side of" of large records in a file, do this: Place the number of bytes to cut after the /H switch such as this (for 256 bytes) >CUTZ-SDF B:MYDATA.1 /H 256 Here is a picture of two files created from one file that contained the alphabet. It was Hacked at 15 (ie /H 15) before: B:MYDATA.1 ┌──────────────────────────┐ │ABCDEFGHIJKLMNOPQRSTUVWXYZ│ │ABCDEFGHIJKLMNOPQRSTUVWXYZ│ │ABCDEFGHIJKLMNOPQRSTUVWXYZ│ │ABCDEFGHIJKLMNOPQRSTUVWXYZ│ │ABCDEFGHIJKLMNOPQRSTUVWXYZ│ │ABCDEFGHIJKLMNOPQRSTUVWXYZ│ │ABCDEFGHIJKLMNOPQRSTUVWXYZ│ │ABCDEFGHIJKLMNOPQRSTUVWXYZ│ │ABCDEFGHIJKLMNOPQRSTUVWXYZ│ │ABCDEFGHIJKLMNOPQRSTUVWXYZ│ │ABCDEFGHIJKLMNOPQRSTUVWXYZ│ └──────────────────────────┘ After the Hack at 15 bytes by doing this >CUTZ-SDF B:MYDATA.1 /H 15 B:MYDATA.LEF B:MYDATA.RIG ┌───────────────┐ ┌───────────┐ │ABCDEFGHIJKLMNO│ │PQRSTUVWXYZ│ │ABCDEFGHIJKLMNO│ │PQRSTUVWXYZ│ │ABCDEFGHIJKLMNO│ │PQRSTUVWXYZ│ │ABCDEFGHIJKLMNO│ │PQRSTUVWXYZ│ │ABCDEFGHIJKLMNO│ you make │PQRSTUVWXYZ│ │ABCDEFGHIJKLMNO│<-----------and----------->│PQRSTUVWXYZ│ │ABCDEFGHIJKLMNO│ │PQRSTUVWXYZ│ │ABCDEFGHIJKLMNO│ │PQRSTUVWXYZ│ │ABCDEFGHIJKLMNO│ │PQRSTUVWXYZ│ │ABCDEFGHIJKLMNO│ │PQRSTUVWXYZ│ │ABCDEFGHIJKLMNO│ │PQRSTUVWXYZ│ └───────────────┘ └───────────┘ At this point, you MAY want to rename the two files Later, To GLUE them BOTh back together, use the /G switch >CUTZ-SDF B:MYDATA.LEF B:MYDATA.RIG /G ~~~ ~~~ Notice that the "LEFt" side goes first and then the "RIGht" You will make a new file> B:MYDATA.BOT, "BOT" means "BOTH" If you were to "/G" (glue) these two files together, the .LEF and .RIG files, to make ".BOT" it would look like the original B:MYDATA.1 if no changes were made to the ".LEF" or ".RIG" file. You can Glue, /G, only two files together at a time. Remember, Gluing is "side by side" while DOS' COPY is "end to end" --------------------------------------------------------------- /T The Syntax to test lines in CUTZTEST.1 is this: ~~~~~~~~~~ >CUTZ-SDF CUTZTEST.1 /T ~~~~~~~~~~ where the name of the file comes directly after the CUTZ-SDF.EXE file name. It can be in any path. Here, it is in the same path with the CUTZ-SDF.EXE file. The /T switch tells it to TEST. --------------------------------------------------------------- /F ### The Syntax to fix the length of each record is this: >CUTZ-SDF CUTZTEST.1 /F ### where the name of the file to fix comes directly after the CUTZ-SDF.EXE. Here, it is the CUTZTEST.1 file. The /F says to FIX the length of each record in CUTZTEST.1 . The number, ###, after the /F tells how long to make each record. The extra bytes are Chopped Off the right side of each record to insure that each record is the size, ###. The new FILE name created will contain the number/size, ###, in its name. For instance: If you used /F 65 for the size, then the new file would be named SIZE65.SDF . Each record would be chopped so that they all would be 65 bytes long and... if a record were less than 65 characters then it would automatically be PADDED with ASCII 32 (hex 20), a space, until it reaches a length of 65. But, you don't HAVE TO pad with spaces (ASCII 32). --------------------------------------------------------------- /F ### /P ### Or, if you want it padded with another ASCII character then include the switch /P ### somewhere on the line, also. The ### is a decimal number 0 to 255. Example: To make them all 65 chrs and pad with a "9" if any are "shorter" than 65 characters. (The character "9" is ASCII decimal 57.) >CUTZ-SDF CUTZTEST.1 /F 65 /P 57 This will work just as well (with NO spaces in the switch): >CUTZ-SDF CUTZTEST.1 /P57 /F65 (notice the P before F) Or even this: >CUTZ-SDF cutztest.1 /F65/P57 (notice the F before P, again) However, you must leave one space (or two) between the SDF Filename and the Switches so I can tell where one leaves and the other takes off..... With /P 57 as a switch, any SHORT RECORD would be padded with the character "9", an ASCII 57, to make it have a length of 65 characters. MOST PADDING is done with decimal ASCII 32, the space character. And all along, you thought that George Jetson was the space character!!! Here is the group of the above SDF records after you FIXED the length to be 65 and used the character "9" to do the PADDING. ROPER DAVID GARNER NC27529CUTZSDF1EXE19891120SWM9999 MCDUFFIE KATHRYN RALEIGH NC27611CUTZSDF2COM19891227DMF9999 TRUMAN TEE WILSON NC27456CUTZSDF3BAT19900509SBM9999 BRANCOWITZ ADRIAN ELLOREE SC26543CUTZSDF4COM19900510BDW9999 WILSON KAY COLUMBIA SC29206CUTZSDF5EXE19900512SWW9999 ^^^^ 12345678901234567890123456789012345678901234567890123456789012345 1 2 3 4 5 6 YOU WILL NEVER HURT THE ORIGINAL... and especially NOT if you copy your original and rename the ".SDF" extension to a number such as ".1" Most SDF downloads will have an EXTENSION of SDF so that you will know what type of file it is. Not always! /S ## will change the default number of seconds for the DEMO and the other timed events in CUTZ-SDF. If you want a fast DEMO, then start your session with> CUTZ-SDF /S .1 for a tenth of a second delay. The maximum delay is 10 seconds, but who would want that? It's boring enough at a delay of 2 seconds. =============================================================== LOOKUP feature: (explained) Added with the version 1.8 is the ability for you to inspect a portion of a record and see if it is contained in another file. If it is, then the string (or numbers) associated with the word found will be put into the record at that point. This is similar to a table lookup. At position 50 in the record, if you find XYZ, replace with ABC, find DEF replace with TUV, twenty-five combinations can be used at one time. First, you create a file using DOS or any plain ASCII editor. WORD PERFECT, WORD STAR and MICROSOFT WORD won't make ASCII text unless you force them. Sometimes they refer to ASCII as "DOS FORMAT." Why don't they just say "ASCII?" You might use PCWRITE, QEDIT, E88, PDE, or 999 others. In the file, on each line are two words, separated by a comma. The left side contains the "word" you are looking for... ....then comes the comma.... ....then the right side contains the "word" that you want to have pasted into the record where the first word was. What a mouthful! The Left side should be the same number of CHRS as the right side if you're REALLY just going to REPLACE CHRS. Like this: 01,AL 02,NU 03,LO 04,XX If you want to put a REMark or comment into your file along WITH THE DATA (ie WITH the four items, the four lines), you can. Just START THE LINE with three chrs, "REM" (or rem.) Any line with the FIRST 3 chrs as REM will be skipped and ignored. Here is the file above with REMarks added into the file. Don't use the Quotes around REM as above. 01,AL REM AL is Alphabetical Type - this is a comment 02,NU REM NU is Numeric Type in version 3.28 - this is a comment 03,LO REM 03 is the db:PICK5 code for LOGICAL, not the dBAS3:R code rem because that stopped in 1987 with version 3.31 rem - this is the third line of a big comment 04,XX ^ ^ PLEASE NOTE THIS: The hat ^, or arrow ^, here is pointing to the FIRST character, first column in the file, but due to this DOCUMENT having MARGINS, it doesn't look like the first column/character. Make the name of the file: CUTZLOOK.UP. Actually, make it anything you want. You will get the opportunity to tell the CUTZ-SDF what the name of it is, later on, when you use it. Here's what happens using the above example. When "01" is found, then "AL" will be put there in its place. If "02" is found instead, then "NU" will be used. If "03" is found, then "LO" will be pasted, and if "04" is found, we will put "XX" there. There are four, 4, examples in this file. The length of the item on the Left side must be the same as the length of the item on the Right side for a proper substitution. This example above is showing four, 4, items on the left side, to be searched or looked up. The number that CUTZ-SDF normally handles is up to 25 items. If you need for it to handle more than 25, then use /DIM ## as a switch. For example: if you need to have 78 items (78 lines, each line contains a comma and two words) then use this switch> CUTZ-SDF /DIM 78 The Maximum size that the Switch /DIM will take is 1000 --- if your RAM memory can hold it, that is. Each line takes 10 bytes of RAM memory for the arrays BEFORE the item (the actual word) is placed into RAM. The above 4 lines take 4*10 or 40 bytes for the array pointers and another 4*2 + 4*2 (=16) for the eight words or strings. That's a total of a whopping 56 bytes which any PC can handle easily. But, you have a PCjr? Oops. Again, 25 items (or lines) is the normal value without having to use any /DIM Switch at all. How do you use this LOOKUP feature, now that you have created the file? Easy, Select "CHANGE" as your choice of the options. But, wait, there's more. It's easy, though. To use the Table Lookup file that you have created, simply put the name of the file into the "DATA to look for" quotes (as if THAT is what you were looking for.) You must also, put the name AGAIN into the quotes when it asks "Change to what DATA?" The key (secret) to using your LOOKUP file is to put the LOOKUP filename TWICE instead of the actual DATA or word, etc. when you use the CHANGE option. Both times, type the same thing, the same filename (and path if used.) If I see an exact match then I will use that FILESPEC as the source of things to try to find and change. It's easier to use than it is to explain or write about. In fact, CTL-F will duplicate the filename for you without your having to type it in again. ^-F means CONTROL-F. If you took my advice and named the file CUTZLOOK.UP then you can have that name placed inside the quotes by doing an ALT-F, abbreviated as @-F. That's the lazy way out if you don't have a lot of different Lookup Files to choose from. =============================================================== The CUTZ-SDF program will look blue and white on a color monitor and look Black and white on a NON-color monitor such as a Hercules Amber, etc. If you want different colors send me $100 and you will get it. I'll even pay the postage, heh, heh. Better Still, use two "undocumented switches" called /W and /B. /W# for Word color (foreground) and /B# for Background color. An example for RED words on GREEN would be >CUTZ-SDF /W 4 /B2 Use these Colors: 0 black, 1 blue, 2 green, 4 red, 7 white, etc. You can find more in any BASIC manual that comes with DOS. HISTORY ========= V 1.0 NOV 20,'89 ...Beta only. It moves chrs to right side of a position. v 1.1 DEC 27,'89 ...Added the variable Ruler (reverse color) to ease counting the positions v 1.2 JAN 09,'90 ...Enabled padding on right and left sides and added automatically incrementing extensions because I'm lazy. v 1.3 FEB 10,'90 ...Added the /T, /F, /P command line switches for people who first need to TEST and FIX (and PAD) the original SDF file. v 1.4 MAR 12,'90 ...Changed Screens slightly. Cosmetic. Added SDF examples to DOC file. Added sample files to play with. v 1.5 APR 14,'90 ...Minor "record counting" bug fix Does not affect operation. v 1.6 MAY 17,'90 ...Added DEMO on first screen, better error trapping, a "power meter" when records are being changed, and two switches: /GLUE and /HACK. v 1.7 MAY 21,'90 ...Added "Change" to the Choices. CUTZ-SDF will look for a string at a position and change it into another string IF IT FINDS IT. v 1.8 JUL 9,'90 ...Added the LOOKUP file to the CHANGE option. Made some of the inputs to allow a space chr at the end of a string. Added /DIM## Added Arrow keys to scroll records. Added /B# and /W# for screen colors. Added Alt-J. v 1.9 JUL 30,'90 ...Cosmetic changes to screen, not affecting any data Input or data Output. Allow exit if "No" to question "File only 1 byte, Delete it ?" (It was in a loop.) v 2.0 AUG 8,'90 ...Adjusted "Power Meter/Bar" Action. Fixed bug which sometimes hangs using "View Next Record" arrows. Quit now tells "New file not made." Thank you for trying and using CUTZ-SDF. I hope it helped you at work with that "pesky" SDF file. Send me just a card if it did. If you want a reply....be sure to send a SASE along since I'm not charging money for CUTZ-SDF. This is FREEWARE. If you liked this program, MAYBE you would like ANOTHER one which I wrote called CUTZIT which is also FREEWARE (no money, payment is required to use it, either). It CUTs up records and files in 35 or 40 different methods - a virtual LIBRARY of Utilities to cut up, chop, and slice any ASCII and/or Binary file - and it's all in one easy to use program and menu driven. Please order it from the same place you got this program. If you MUST order from me, the price is $15 which pays for the diskette, mailer, postage, handling, and my Lunch. (You're Still "Free" to distribute it, however.) I DON'T WANT TO COMPETE WITH COMPANIES WHO DISTRIBUTE MY SOFTWARE. $15 SHOULD PROVE THAT, yet make CUTZIT available to anyone who truly cannot find my programs. $15 is about what the shareware price would be IF it WERE shareware (subjunctive case),.... which is isn't. Get that frown off your face.... Why is it free? Perhaps as a payback for all those programs I have used by people who placed their programs into the Public Domain and/or at no charge FREEWARE. My thanks go to them. My thanks go, also, to those companies who distribute these Public Domain, Shareware and Freeware programs for us all. ----------------- eof ----------------- ----------------end-of-author's-documentation--------------- Software Library Information: This disk copy provided as a service of Public (software) Library We are not the authors of this program, nor are we associated with the author in any way other than as a distributor of the program in accordance with the author's terms of distribution. Please direct shareware payments and specific questions about this program to the author of the program, whose name appears elsewhere in this documentation. If you have trouble getting in touch with the author, we will do whatever we can to help you with your questions. All programs have been tested and do run. To report problems, please use the form that is in the file PROBLEM.DOC on many of our disks or in other written for- mat with screen printouts, if possible. PsL cannot debug pro- programs over the telephone, though we can answer questions. Disks in the PsL are updated monthly, so if you did not get this disk directly from the PsL, you should be aware that the files in this set may no longer be the current versions. Also, if you got this disk from another vendor and are having prob- lems, be aware that some files may have become corrupted or lost by that vendor. Get a current, working disk from PsL. For a copy of the latest monthly software library newsletter and a list of the 2,000+ disks in the library, call or write Public (software) Library P.O.Box 35705 - F Houston, TX 77235-5705 1-800-2424-PSL MC/Visa/AmEx/Discover Outside of U.S. or in Texas or for general information, Call 1-713-524-6394 PsL also has an outstanding catalog for the Macintosh.